<?php
/* -------------------------------------------------------------------------------------
* 	ID:						$Id: validproducts.php 127 2013-09-21 12:11:50Z phone.mueller@googlemail.com $
* 	Letzter Stand:			$Revision: 127 $
* 	zuletzt geaendert von:	$Author: peter $
* 	Datum:					$Date: 2013-09-21 12:11:50 +0000 (Sat, 21 Sep 2013) $
*
* 	SEO:mercari by Siekiera Media
* 	http://www.seo-mercari.de
*
* 	Copyright (c) since 2011 SEO:mercari
* --------------------------------------------------------------------------------------
* 	based on:
* 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
* 	(c) 2002-2003 osCommerce - www.oscommerce.com
* 	(c) 2003     nextcommerce - www.nextcommerce.org
* 	(c) 2005     xt:Commerce - www.xt-commerce.com
*
* 	Released under the GNU General Public License
* ----------------------------------------------------------------------------------- */

require('includes/application_top.php');
?>
<html>
	<head>
		<title>Produktliste</title>
		<link rel="stylesheet" type="text/css" href="includes/popup.css">
	<head>
	<body>
		<fieldset>
			<legend><?php echo TEXT_VALID_PRODUCTS_LIST; ?></legend>
			<table class="dataTable" width="100%">
			<?
			echo '	<tr class="dataTableRow">
						<th width="33.3%">'.TEXT_VALID_PRODUCTS_ID.'</th>
						<th width="33.3%">'.TEXT_VALID_PRODUCTS_NAME.'</th>
						<th width="33.3%">'.TEXT_VALID_PRODUCTS_MODEL.'</th>
					</tr>';
			
			$result = $db->db_query("	SELECT 
											* 
										FROM 
											".TABLE_PRODUCTS." p, 
											".TABLE_PRODUCTS_DESCRIPTION." pd 
										WHERE 
											p.products_id = pd.products_id 
										AND 
											pd.language_id = '".$_SESSION['languages_id']."' 
										ORDER BY 
											pd.products_name");
			
			while(!$result->EOF) {
				echo '</tr>';
				echo '	<td align="center">'.$result->fields['products_id'].'</td>';
				echo '	<td align="center">'.$result->fields['products_name'].'</td>';
				echo '	<td align="center">'.$result->fields['products_model'].'</td>';
				echo '</tr>';
				$result->MoveNext();
			}
			?>
				
			
			</table>
<input class="button ar" type="submit" value="Fenster schließen" onClick="window.close()">
		</fieldset>
	</body>
</html>